CREATE TABLE [dbo].[ContactSalutation]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[SalutationKey] [uniqueidentifier] NOT NULL,
[SalutationText] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsOverridden] [bit] NOT NULL,
[ContactSalutationKey] [uniqueidentifier] NOT NULL,
[IsDeletable] [bit] NOT NULL CONSTRAINT [DF_ContactSalutation_IsDeletable] DEFAULT ((1)),
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContactSalutation] ADD CONSTRAINT [PK_ContactSalutation] PRIMARY KEY CLUSTERED ([ContactSalutationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactSalutation] ADD CONSTRAINT [AK_ContactSalutation] UNIQUE NONCLUSTERED ([ContactKey], [SalutationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactSalutation] ADD CONSTRAINT [FK_ContactSalutation_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[ContactSalutation] ADD CONSTRAINT [FK_ContactSalutation_SalutationRef] FOREIGN KEY ([SalutationKey]) REFERENCES [dbo].[SalutationRef] ([SalutationKey])
GO